SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Partners](
	[PartnerID] [INT] IDENTITY(1,1) NOT NULL,
	[PartnerCode] [NVARCHAR](50) NOT NULL,
	[PartnerName] [NVARCHAR](50) NULL,
	[Representer] [NVARCHAR](50) NULL,
	[Role] [NVARCHAR](50) NULL,
	[Address1] [NVARCHAR](50) NULL,
	[Address2] [NVARCHAR](50) NULL,
	[ContactName1] [NVARCHAR](50) NULL,
	[ContactName2] [NVARCHAR](50) NULL,
	[Phone1] [NVARCHAR](15) NULL,
	[Phone2] [NVARCHAR](15) NULL,
	[Description] [NVARCHAR](200) NULL,
	[CreatedBy] [INT] NOT NULL,
	[CreatedDate] [DATETIME] NOT NULL,
	[UpdatedBy] [INT] NOT NULL,
	[UpdatedDate] [DATETIME] NOT NULL,
	[IsDeleted] [BIT] NOT NULL,
	[IsActived] [BIT] NOT NULL,
	[Tstamp] [TIMESTAMP] NOT NULL,
 CONSTRAINT [PK_Partners] PRIMARY KEY CLUSTERED 
(
	[PartnerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


